Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	137681
Missing cells	2123
Missing cells (%)	0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	16.8 MiB
Average record size in memory	128.0 B

Variable types

Numeric	14
Unsupported	2

Alerts

`df_index` is highly correlated with `data_arc` and 2 other fields	High correlation
`a` is highly correlated with `q` and 3 other fields	High correlation
`e` is highly correlated with `q` and 1 other fields	High correlation
`q` is highly correlated with `a` and 4 other fields	High correlation
`ad` is highly correlated with `a` and 3 other fields	High correlation
`per_y` is highly correlated with `a` and 3 other fields	High correlation
`data_arc` is highly correlated with `df_index` and 2 other fields	High correlation
`n_obs_used` is highly correlated with `df_index` and 3 other fields	High correlation
`H` is highly correlated with `df_index` and 2 other fields	High correlation
`albedo` is highly correlated with `n_obs_used`	High correlation
`moid` is highly correlated with `a` and 4 other fields	High correlation
`df_index` is highly correlated with `data_arc` and 2 other fields	High correlation
`a` is highly correlated with `ad` and 1 other fields	High correlation
`e` is highly correlated with `q`	High correlation
`q` is highly correlated with `e` and 1 other fields	High correlation
`ad` is highly correlated with `a` and 1 other fields	High correlation
`per_y` is highly correlated with `a` and 1 other fields	High correlation
`data_arc` is highly correlated with `df_index` and 2 other fields	High correlation
`n_obs_used` is highly correlated with `df_index` and 2 other fields	High correlation
`H` is highly correlated with `df_index` and 2 other fields	High correlation
`moid` is highly correlated with `q`	High correlation
`df_index` is highly correlated with `data_arc` and 2 other fields	High correlation
`a` is highly correlated with `q` and 3 other fields	High correlation
`q` is highly correlated with `a` and 2 other fields	High correlation
`ad` is highly correlated with `a` and 1 other fields	High correlation
`per_y` is highly correlated with `a` and 3 other fields	High correlation
`data_arc` is highly correlated with `df_index` and 1 other fields	High correlation
`n_obs_used` is highly correlated with `df_index` and 2 other fields	High correlation
`H` is highly correlated with `df_index` and 1 other fields	High correlation
`moid` is highly correlated with `a` and 2 other fields	High correlation
`df_index` is highly correlated with `data_arc` and 2 other fields	High correlation
`a` is highly correlated with `e` and 5 other fields	High correlation
`e` is highly correlated with `a` and 2 other fields	High correlation
`i` is highly correlated with `a` and 3 other fields	High correlation
`q` is highly correlated with `a` and 1 other fields	High correlation
`ad` is highly correlated with `a` and 3 other fields	High correlation
`per_y` is highly correlated with `a` and 2 other fields	High correlation
`data_arc` is highly correlated with `df_index` and 2 other fields	High correlation
`n_obs_used` is highly correlated with `df_index` and 2 other fields	High correlation
`H` is highly correlated with `df_index` and 2 other fields	High correlation
`moid` is highly correlated with `a` and 1 other fields	High correlation
`a` is highly skewed (γ1 = 179.5477471)	Skewed
`ad` is highly skewed (γ1 = 203.526581)	Skewed
`per_y` is highly skewed (γ1 = 254.3038078)	Skewed
`df_index` has unique values	Unique
`a` has unique values	Unique
`e` has unique values	Unique
`i` has unique values	Unique
`om` has unique values	Unique
`w` has unique values	Unique
`q` has unique values	Unique
`ad` has unique values	Unique
`per_y` has unique values	Unique
`condition_code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`diameter` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2022-10-01 18:50:24.729849
Analysis finished	2022-10-01 18:51:22.288179
Duration	57.56 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	137681
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	193659.6741

Minimum	0
Maximum	810411
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	7664
Q1	49981
median	131754
Q3	269078
95-th percentile	627536
Maximum	810411
Range	810411
Interquartile range (IQR)	219097

Descriptive statistics

Standard deviation	183351.5803
Coefficient of variation (CV)	0.9467721203
Kurtosis	0.5740239775
Mean	193659.6741
Median Absolute Deviation (MAD)	101005
Skewness	1.186224009
Sum	2.666325759 × 10¹⁰
Variance	3.3617802 × 10¹⁰
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
232507	1	< 0.1%
232549	1	< 0.1%
232545	1	< 0.1%
232533	1	< 0.1%
232532	1	< 0.1%
232531	1	< 0.1%
232528	1	< 0.1%
232525	1	< 0.1%
232524	1	< 0.1%
Other values (137671)	137671	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
810411	1	< 0.1%
799788	1	< 0.1%
798225	1	< 0.1%
798113	1	< 0.1%
797896	1	< 0.1%
797871	1	< 0.1%
797841	1	< 0.1%
797473	1	< 0.1%
797445	1	< 0.1%
797427	1	< 0.1%

a
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
UNIQUE

Distinct	137681
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.814523873

Minimum	0.6262255386
Maximum	389.1459642
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.6262255386
5-th percentile	2.245546661
Q1	2.536646609
median	2.750781171
Q3	3.09250633
95-th percentile	3.217469342
Maximum	389.1459642
Range	388.5197387
Interquartile range (IQR)	0.5558597209

Descriptive statistics

Standard deviation	1.522511817
Coefficient of variation (CV)	0.5409482692
Kurtosis	40400.97362
Mean	2.814523873
Median Absolute Deviation (MAD)	0.3153860786
Skewness	179.5477471
Sum	387506.4613
Variance	2.318042234
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.769165155	1	< 0.1%
2.781799853	1	< 0.1%
3.11199728	1	< 0.1%
3.082199598	1	< 0.1%
2.754508774	1	< 0.1%
2.707900166	1	< 0.1%
3.175269133	1	< 0.1%
2.664285082	1	< 0.1%
2.745605	1	< 0.1%
3.058250624	1	< 0.1%
Other values (137671)	137671	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.6262255386	1	< 0.1%
0.6421955963	1	< 0.1%
0.6618373107	1	< 0.1%
0.6822659377	1	< 0.1%
0.7120675097	1	< 0.1%
0.7200464602	1	< 0.1%
0.7283806724	1	< 0.1%
0.7387345695	1	< 0.1%
0.7466790621	1	< 0.1%
0.7615842071	1	< 0.1%

Value	Count	Frequency (%)
389.1459642	1	< 0.1%
290.0792389	1	< 0.1%
167.1685521	1	< 0.1%
69.57683324	1	< 0.1%
66.83974139	1	< 0.1%
63.22531764	1	< 0.1%
53.92018994	1	< 0.1%
53.00004854	1	< 0.1%
42.78126679	1	< 0.1%
39.41933525	1	< 0.1%

e
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	137681
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.145477916

Minimum	0.0004885363213
Maximum	0.9843481641
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.0004885363213
5-th percentile	0.03819892262
Q1	0.08961122155
median	0.1385379705
Q3	0.1911336558
95-th percentile	0.2723651364
Maximum	0.9843481641
Range	0.9838596277
Interquartile range (IQR)	0.1015224342

Descriptive statistics

Standard deviation	0.07757133208
Coefficient of variation (CV)	0.5332172347
Kurtosis	6.912563996
Mean	0.145477916
Median Absolute Deviation (MAD)	0.05066622246
Skewness	1.395743109
Sum	20029.54495
Variance	0.006017311561
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0760090291	1	< 0.1%
0.1278541494	1	< 0.1%
0.1708786843	1	< 0.1%
0.06500589472	1	< 0.1%
0.1913978811	1	< 0.1%
0.05970405074	1	< 0.1%
0.1812825219	1	< 0.1%
0.1042453543	1	< 0.1%
0.0715830867	1	< 0.1%
0.07596720077	1	< 0.1%
Other values (137671)	137671	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0004885363213	1	< 0.1%
0.0006014718155	1	< 0.1%
0.0007079913616	1	< 0.1%
0.0008850430483	1	< 0.1%
0.0009516743783	1	< 0.1%
0.001002645567	1	< 0.1%
0.001140725861	1	< 0.1%
0.001207752737	1	< 0.1%
0.00131996013	1	< 0.1%
0.001387525699	1	< 0.1%

Value	Count	Frequency (%)
0.9843481641	1	< 0.1%
0.9683810631	1	< 0.1%
0.967772907	1	< 0.1%
0.9676043222	1	< 0.1%
0.9625832101	1	< 0.1%
0.9544802864	1	< 0.1%
0.9474635949	1	< 0.1%
0.9411376922	1	< 0.1%
0.9242421043	1	< 0.1%
0.9186296258	1	< 0.1%

i
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	137681
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.35085027

Minimum	0.02185489629
Maximum	170.3236472
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.02185489629
5-th percentile	1.977917381
Q1	5.121634134
median	9.391665752
Q3	13.74234679
95-th percentile	24.77355997
Maximum	170.3236472
Range	170.3017923
Interquartile range (IQR)	8.62071266

Descriptive statistics

Standard deviation	6.835959366
Coefficient of variation (CV)	0.660424911
Kurtosis	13.04169278
Mean	10.35085027
Median Absolute Deviation (MAD)	4.302604195
Skewness	1.635546681
Sum	1425115.416
Variance	46.73034046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.59406704	1	< 0.1%
4.680770625	1	< 0.1%
27.93369039	1	< 0.1%
9.226990288	1	< 0.1%
4.697489972	1	< 0.1%
6.663248467	1	< 0.1%
9.101697663	1	< 0.1%
14.17207568	1	< 0.1%
5.463946935	1	< 0.1%
9.725183079	1	< 0.1%
Other values (137671)	137671	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02185489629	1	< 0.1%
0.04271022441	1	< 0.1%
0.04473844113	1	< 0.1%
0.04926098664	1	< 0.1%
0.05046045974	1	< 0.1%
0.05295228189	1	< 0.1%
0.05497415806	1	< 0.1%
0.06162994635	1	< 0.1%
0.06655157512	1	< 0.1%
0.06671149151	1	< 0.1%

Value	Count	Frequency (%)
170.3236472	1	< 0.1%
158.5353939	1	< 0.1%
151.813136	1	< 0.1%
143.9201996	1	< 0.1%
143.9119456	1	< 0.1%
140.7490661	1	< 0.1%
129.2463878	1	< 0.1%
123.7105136	1	< 0.1%
121.3843551	1	< 0.1%
118.9699654	1	< 0.1%

om
Real number (ℝ_≥0)

UNIQUE

Distinct	137681
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	169.8289534

Minimum	0.0007349159453
Maximum	359.9908583
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.0007349159453
5-th percentile	18.21759499
Q1	82.3300395
median	160.4385012
Q3	256.2797292
95-th percentile	341.182864
Maximum	359.9908583
Range	359.9901234
Interquartile range (IQR)	173.9496897

Descriptive statistics

Standard deviation	102.7133349
Coefficient of variation (CV)	0.6048046157
Kurtosis	-1.133406742
Mean	169.8289534
Median Absolute Deviation (MAD)	85.31167554
Skewness	0.1837598518
Sum	23382220.14
Variance	10550.02917
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80.30553157	1	< 0.1%
188.2680781	1	< 0.1%
223.4525256	1	< 0.1%
328.6715185	1	< 0.1%
127.8848724	1	< 0.1%
282.4506704	1	< 0.1%
294.3332254	1	< 0.1%
346.8812277	1	< 0.1%
152.2712838	1	< 0.1%
356.371201	1	< 0.1%
Other values (137671)	137671	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0007349159453	1	< 0.1%
0.0009165999208	1	< 0.1%
0.001246082431	1	< 0.1%
0.003670260041	1	< 0.1%
0.003841341213	1	< 0.1%
0.004665609432	1	< 0.1%
0.01369179721	1	< 0.1%
0.01496666608	1	< 0.1%
0.01690936444	1	< 0.1%
0.01748	1	< 0.1%

Value	Count	Frequency (%)
359.9908583	1	< 0.1%
359.98405	1	< 0.1%
359.9756694	1	< 0.1%
359.9664038	1	< 0.1%
359.9646583	1	< 0.1%
359.960559	1	< 0.1%
359.9522929	1	< 0.1%
359.9480962	1	< 0.1%
359.9449128	1	< 0.1%
359.9394734	1	< 0.1%

w
Real number (ℝ_≥0)

UNIQUE

Distinct	137681
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	181.8997547

Minimum	0.004466267278
Maximum	359.9951738
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.004466267278
5-th percentile	18.85333456
Q1	91.9361685
median	183.6624273
Q3	271.7611751
95-th percentile	341.839216
Maximum	359.9951738
Range	359.9907076
Interquartile range (IQR)	179.8250066

Descriptive statistics

Standard deviation	103.5575925
Coefficient of variation (CV)	0.5693113369
Kurtosis	-1.204809803
Mean	181.8997547
Median Absolute Deviation (MAD)	89.87311482
Skewness	-0.02810874002
Sum	25044140.13
Variance	10724.17497
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73.59769412	1	< 0.1%
204.1293854	1	< 0.1%
168.2212453	1	< 0.1%
25.28082103	1	< 0.1%
225.2814349	1	< 0.1%
22.86220635	1	< 0.1%
63.66679571	1	< 0.1%
231.4567475	1	< 0.1%
225.8820344	1	< 0.1%
355.3654357	1	< 0.1%
Other values (137671)	137671	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.004466267278	1	< 0.1%
0.005880450149	1	< 0.1%
0.0102245282	1	< 0.1%
0.01133574543	1	< 0.1%
0.01187402502	1	< 0.1%
0.01287431658	1	< 0.1%
0.01293251321	1	< 0.1%
0.01563579244	1	< 0.1%
0.01618825405	1	< 0.1%
0.01763990551	1	< 0.1%

Value	Count	Frequency (%)
359.9951738	1	< 0.1%
359.9931625	1	< 0.1%
359.9888857	1	< 0.1%
359.9884618	1	< 0.1%
359.9852623	1	< 0.1%
359.9839384	1	< 0.1%
359.9807902	1	< 0.1%
359.9734163	1	< 0.1%
359.9730407	1	< 0.1%
359.9714942	1	< 0.1%

q
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	137681
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.402551476

Minimum	0.08188215046
Maximum	40.46567139
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.08188215046
5-th percentile	1.809358256
Q1	2.068878638
median	2.363854066
Q3	2.685775789
95-th percentile	2.995294493
Maximum	40.46567139
Range	40.38378924
Interquartile range (IQR)	0.6168971512

Descriptive statistics

Standard deviation	0.5161361597
Coefficient of variation (CV)	0.214828346
Kurtosis	345.6218442
Mean	2.402551476
Median Absolute Deviation (MAD)	0.3082834301
Skewness	7.31135831
Sum	330785.6898
Variance	0.2663965354
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.5586836	1	< 0.1%
2.426135199	1	< 0.1%
2.580223279	1	< 0.1%
2.881838455	1	< 0.1%
2.227301631	1	< 0.1%
2.546227557	1	< 0.1%
2.599648337	1	< 0.1%
2.38654574	1	< 0.1%
2.549066119	1	< 0.1%
2.825923885	1	< 0.1%
Other values (137671)	137671	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.08188215046	1	< 0.1%
0.09204753842	1	< 0.1%
0.09556304967	1	< 0.1%
0.1109985058	1	< 0.1%
0.1399811196	1	< 0.1%
0.145153872	1	< 0.1%
0.1865882411	1	< 0.1%
0.1953860287	1	< 0.1%
0.1999024992	1	< 0.1%
0.1999140771	1	< 0.1%

Value	Count	Frequency (%)
40.46567139	1	< 0.1%
32.03299496	1	< 0.1%
20.99186488	1	< 0.1%
18.74676259	1	< 0.1%
18.01111857	1	< 0.1%
17.57997754	1	< 0.1%
15.25418229	1	< 0.1%
14.94801343	1	< 0.1%
13.15958348	1	< 0.1%
13.1387665	1	< 0.1%

ad
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
UNIQUE

Distinct	137681
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.226496269

Minimum	0.999955915
Maximum	772.2010796
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.999955915
5-th percentile	2.523068374
Q1	2.864377243
median	3.167359606
Q3	3.468509739
95-th percentile	3.907310465
Maximum	772.2010796
Range	771.2011237
Interquartile range (IQR)	0.6041324964

Descriptive statistics

Standard deviation	2.895918499
Coefficient of variation (CV)	0.8975428011
Kurtosis	48076.96572
Mean	3.226496269
Median Absolute Deviation (MAD)	0.3022285751
Skewness	203.526581
Sum	444227.2328
Variance	8.386343953
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.979646709	1	< 0.1%
3.137464508	1	< 0.1%
3.64377128	1	< 0.1%
3.28256074	1	< 0.1%
3.281715917	1	< 0.1%
2.869572775	1	< 0.1%
3.750889929	1	< 0.1%
2.942024424	1	< 0.1%
2.942143881	1	< 0.1%
3.290577364	1	< 0.1%
Other values (137671)	137671	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.999955915	1	< 0.1%
1.014592312	1	< 0.1%
1.015675213	1	< 0.1%
1.018681472	1	< 0.1%
1.020146486	1	< 0.1%
1.027602651	1	< 0.1%
1.031024797	1	< 0.1%
1.035574759	1	< 0.1%
1.038117269	1	< 0.1%
1.038784124	1	< 0.1%

Value	Count	Frequency (%)
772.2010796	1	< 0.1%
570.7611642	1	< 0.1%
328.9497476	1	< 0.1%
136.5503247	1	< 0.1%
122.7290472	1	< 0.1%
112.6876179	1	< 0.1%
105.3859483	1	< 0.1%
87.25333449	1	< 0.1%
59.81484814	1	< 0.1%
58.52906669	1	< 0.1%

per_y
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
UNIQUE

Distinct	137681
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.883984786

Minimum	0.4955692661
Maximum	7676.742943
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.4955692661
5-th percentile	3.365048501
Q1	4.040156183
median	4.562388528
Q3	5.438436952
95-th percentile	5.771382102
Maximum	7676.742943
Range	7676.247374
Interquartile range (IQR)	1.398280769

Descriptive statistics

Standard deviation	25.52840024
Coefficient of variation (CV)	5.226961458
Kurtosis	69768.00063
Mean	4.883984786
Median Absolute Deviation (MAD)	0.7900429081
Skewness	254.3038078
Sum	672431.9093
Variance	651.6992186
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.608201802	1	< 0.1%
4.639776085	1	< 0.1%
5.489932634	1	< 0.1%
5.411271712	1	< 0.1%
4.571665458	1	< 0.1%
4.456123058	1	< 0.1%
5.658209385	1	< 0.1%
4.348898201	1	< 0.1%
4.549516955	1	< 0.1%
5.348325269	1	< 0.1%
Other values (137671)	137671	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.4955692661	1	< 0.1%
0.5146466937	1	< 0.1%
0.5384372187	1	< 0.1%
0.5635581523	1	< 0.1%
0.6008830558	1	< 0.1%
0.6110109338	1	< 0.1%
0.6216498342	1	< 0.1%
0.6349519131	1	< 0.1%
0.6452219929	1	< 0.1%
0.6646378908	1	< 0.1%

Value	Count	Frequency (%)
7676.742943	1	< 0.1%
4940.639579	1	< 0.1%
2161.424517	1	< 0.1%
580.3703132	1	< 0.1%
546.4624735	1	< 0.1%
502.7414948	1	< 0.1%
395.9454187	1	< 0.1%
385.8536415	1	< 0.1%
279.8263854	1	< 0.1%
247.4982581	1	< 0.1%

data_arc
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	16832
Distinct (%)	12.2%
Missing	140
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	8678.351023

Minimum	1
Maximum	25109
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	1
5-th percentile	169
Q1	6265
median	7492
Q3	9655
95-th percentile	22449
Maximum	25109
Range	25108
Interquartile range (IQR)	3390

Descriptive statistics

Standard deviation	5160.266163
Coefficient of variation (CV)	0.5946136713
Kurtosis	2.826156243
Mean	8678.351023
Median Absolute Deviation (MAD)	1624
Skewness	1.527000718
Sum	1193629078
Variance	26628346.87
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	4257	3.1%
25109	3440	2.5%
2	1808	1.3%
7150	144	0.1%
5	128	0.1%
4	110	0.1%
7151	103	0.1%
7175	101	0.1%
7149	100	0.1%
7179	95	0.1%
Other values (16822)	127255	92.4%
(Missing)	140	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4257	3.1%
2	1808	1.3%
3	19	< 0.1%
4	110	0.1%
5	128	0.1%
6	44	< 0.1%
7	15	< 0.1%
8	6	< 0.1%
9	6	< 0.1%
10	12	< 0.1%

Value	Count	Frequency (%)
25109	3440	2.5%
25108	2	< 0.1%
25107	6	< 0.1%
25106	2	< 0.1%
25104	2	< 0.1%
25103	4	< 0.1%
25102	2	< 0.1%
25099	1	< 0.1%
25098	1	< 0.1%
25097	1	< 0.1%

condition_code
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

n_obs_used
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3079
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	659.4209513

Minimum	5
Maximum	9325
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	5
5-th percentile	23
Q1	214
median	483
Q3	958
95-th percentile	1846
Maximum	9325
Range	9320
Interquartile range (IQR)	744

Descriptive statistics

Standard deviation	581.894272
Coefficient of variation (CV)	0.8824321866
Kurtosis	2.711255156
Mean	659.4209513
Median Absolute Deviation (MAD)	321
Skewness	1.372468196
Sum	90789736
Variance	338600.9438
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	700	0.5%
11	697	0.5%
12	683	0.5%
10	661	0.5%
14	607	0.4%
9	545	0.4%
15	537	0.4%
8	456	0.3%
16	442	0.3%
17	304	0.2%
Other values (3069)	132049	95.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	82	0.1%
6	165	0.1%
7	268	0.2%
8	456	0.3%
9	545	0.4%
10	661	0.5%
11	697	0.5%
12	683	0.5%
13	700	0.5%
14	607	0.4%

Value	Count	Frequency (%)
9325	1	< 0.1%
8490	1	< 0.1%
8146	1	< 0.1%
7104	1	< 0.1%
6671	1	< 0.1%
6153	1	< 0.1%
6102	1	< 0.1%
6034	1	< 0.1%
5742	1	< 0.1%
5475	1	< 0.1%

H
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	337
Distinct (%)	0.2%
Missing	751
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	15.18753989

Minimum	10.95449944
Maximum	19.40014603
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	10.95449944
5-th percentile	12.8
Q1	14.4
median	15.3
Q3	16.1
95-th percentile	17.2
Maximum	19.40014603
Range	8.445646595
Interquartile range (IQR)	1.7

Descriptive statistics

Standard deviation	1.330430533
Coefficient of variation (CV)	0.08760013423
Kurtosis	0.8054683155
Mean	15.18753989
Median Absolute Deviation (MAD)	0.8
Skewness	-0.467087434
Sum	2079629.837
Variance	1.770045403
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.2	4630	3.4%
15.4	4536	3.3%
15.5	4522	3.3%
15.3	4484	3.3%
15.1	4457	3.2%
15.7	4449	3.2%
15.6	4356	3.2%
14.9	4327	3.1%
15	4275	3.1%
15.9	4147	3.0%
Other values (327)	92747	67.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.95449944	1449	1.1%
10.96	2	< 0.1%
10.97	3	< 0.1%
10.98	2	< 0.1%
10.99	2	< 0.1%
11	82	0.1%
11.01	2	< 0.1%
11.03	2	< 0.1%
11.04	3	< 0.1%
11.05	1	< 0.1%

Value	Count	Frequency (%)
19.40014603	323	0.2%
19.4	21	< 0.1%
19.3	17	< 0.1%
19.2	17	< 0.1%
19.1	16	< 0.1%
19.03	1	< 0.1%
19	13	< 0.1%
18.97	1	< 0.1%
18.95	1	< 0.1%
18.9	16	< 0.1%

diameter
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

albedo
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	628
Distinct (%)	0.5%
Missing	1232
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.1276118938

Minimum	0.001
Maximum	0.3905
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.001
5-th percentile	0.034
Q1	0.053
median	0.078
Q3	0.188
95-th percentile	0.349
Maximum	0.3905
Range	0.3895
Interquartile range (IQR)	0.135

Descriptive statistics

Standard deviation	0.1013404292
Coefficient of variation (CV)	0.7941299682
Kurtosis	0.1581142022
Mean	0.1276118938
Median Absolute Deviation (MAD)	0.035
Skewness	1.156554358
Sum	17412.5153
Variance	0.01026988259
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3905	3809	2.8%
0.057	1669	1.2%
0.055	1655	1.2%
0.053	1650	1.2%
0.052	1636	1.2%
0.049	1629	1.2%
0.051	1628	1.2%
0.056	1616	1.2%
0.054	1606	1.2%
0.048	1606	1.2%
Other values (618)	117945	85.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.001	5	< 0.1%
0.004	2	< 0.1%
0.005	3	< 0.1%
0.006	4	< 0.1%
0.007	3	< 0.1%
0.008	4	< 0.1%
0.009	4	< 0.1%
0.01	8	< 0.1%
0.011	8	< 0.1%
0.0116	1	< 0.1%

Value	Count	Frequency (%)
0.3905	3809	2.8%
0.39	59	< 0.1%
0.3895	1	< 0.1%
0.389	65	< 0.1%
0.388	57	< 0.1%
0.387	48	< 0.1%
0.386	59	< 0.1%
0.385	63	< 0.1%
0.384	58	< 0.1%
0.383	53	< 0.1%

moid
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	94849
Distinct (%)	68.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.420091357

Minimum	0.000166392
Maximum	39.507
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.000166392
5-th percentile	0.823873
Q1	1.08247
median	1.3849
Q3	1.69933
95-th percentile	2.01257
Maximum	39.507
Range	39.50683361
Interquartile range (IQR)	0.61686

Descriptive statistics

Standard deviation	0.5122072452
Coefficient of variation (CV)	0.3606861226
Kurtosis	357.6795121
Mean	1.420091357
Median Absolute Deviation (MAD)	0.30828
Skewness	7.597426504
Sum	195519.5981
Variance	0.262356262
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.09701	9	< 0.1%
1.25351	8	< 0.1%
1.34855	8	< 0.1%
1.2047	8	< 0.1%
1.44447	8	< 0.1%
1.60743	8	< 0.1%
1.13166	7	< 0.1%
1.68616	7	< 0.1%
1.18808	7	< 0.1%
1.88429	7	< 0.1%
Other values (94839)	137604	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.000166392	1	< 0.1%
0.000307103	1	< 0.1%
0.000315683	1	< 0.1%
0.000342079	1	< 0.1%
0.000412369	1	< 0.1%
0.000466802	1	< 0.1%
0.000541511	1	< 0.1%
0.000600408	1	< 0.1%
0.000602857	1	< 0.1%
0.000737031	1	< 0.1%

Value	Count	Frequency (%)
39.507	1	< 0.1%
31.0199	1	< 0.1%
20.1125	1	< 0.1%
18.246	1	< 0.1%
17.0013	1	< 0.1%
16.5916	1	< 0.1%
14.2754	1	< 0.1%
13.9806	1	< 0.1%
12.2113	1	< 0.1%
12.1869	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	a	e	i	om	w	q	ad	per_y	data_arc	n_obs_used	H	diameter	albedo	moid
0	0	2.769165	0.076009	10.594067	80.305532	73.597694	2.558684	2.979647	4.608202	8822.0	1002	10.954499	939.4	0.0900	1.594780
1	1	2.772466	0.230337	34.836234	173.080063	310.048857	2.133865	3.411067	4.616444	25109.0	8490	10.954499	545	0.1010	1.233240
2	2	2.669150	0.256942	12.988919	169.852760	248.138626	1.983332	3.354967	4.360814	25109.0	7104	10.954499	246.596	0.2140	1.034540
3	3	2.361418	0.088721	7.141771	103.810804	150.728541	2.151909	2.570926	3.628837	24288.0	9325	10.954499	525.4	0.3905	1.139480
4	4	2.574249	0.191095	5.366988	141.576604	358.687608	2.082324	3.066174	4.130323	25109.0	2861	10.954499	106.699	0.2740	1.095890
5	5	2.425160	0.203007	14.737901	138.640203	239.807490	1.932835	2.917485	3.776755	25109.0	6034	10.954499	185.18	0.2679	0.973965
6	6	2.385334	0.231206	5.523651	259.563231	145.265106	1.833831	2.936837	3.684105	25109.0	5206	10.954499	199.83	0.2766	0.846100
7	7	2.201764	0.156499	5.886955	110.889330	285.287462	1.857190	2.546339	3.267115	25109.0	2744	10.954499	147.491	0.2260	0.874176
8	8	2.385637	0.123114	5.576816	68.908577	6.417369	2.091931	2.679342	3.684806	25109.0	2649	10.954499	190	0.1180	1.106910
9	9	3.141539	0.112461	3.831560	283.202167	312.315206	2.788240	3.494839	5.568291	25109.0	3409	10.954499	407.12	0.0717	1.778390

Last rows

	df_index	a	e	i	om	w	q	ad	per_y	data_arc	condition_code	n_obs_used	H	diameter	albedo	moid
137671	797427	3.195944	0.232949	26.521186	121.439969	72.849032	2.451453	3.940435	5.713562	2278.0	2	74	16.500000	2.754	0.111	1.590970
137672	797445	3.174505	0.216972	27.544972	282.826248	339.075563	2.485727	3.863283	5.656167	5799.0	1	75	15.300000	4.39	0.076	1.482280
137673	797473	3.194157	0.587350	6.487226	232.633423	68.109831	1.318068	5.070245	5.708770	2229.0	1	89	19.400146	1.849	0.043	0.324697
137674	797841	3.158981	0.315588	23.682254	272.371735	75.070854	2.162046	4.155917	5.614729	6294.0	0	95	15.800000	3.506	0.014	1.280800
137675	797871	3.155975	0.430349	28.718353	115.532995	136.849398	1.797805	4.514145	5.606716	2250.0	2	47	18.200000	1.077	0.116	0.854315
137676	797896	3.171225	0.159119	27.098625	309.036573	19.746812	2.666623	3.675826	5.647402	2373.0	1	50	16.200000	3.793	0.021	1.663010
137677	798113	2.548410	0.076071	11.593237	246.298656	170.090810	2.354549	2.742270	4.068291	3297.0	2	33	17.300000	2.696	0.061	1.367330
137678	798225	3.146246	0.220559	17.966646	137.981403	180.898833	2.452313	3.840180	5.580811	2839.0	1	47	16.800000	2.917	NaN	1.438370
137679	799788	3.051336	0.287449	14.456779	343.917822	342.614839	2.174231	3.928440	5.330196	2208.0	2	27	17.200000	3.271	0.072	1.166840
137680	810411	2.417477	0.109001	4.525668	148.244819	31.949854	2.153970	2.680984	3.758822	3458.0	3	25	18.400000	1.6	0.023	1.159420

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows